Conversion of Fuzzy Query into SQL Query
نویسنده
چکیده
Traditional database systems can deal with perfect data. But lot of information is present in imperfect form due to vagueness or imprecision. [16] Fuzzy set theory has been applied to deal with imperfections of data and to enhance the accessibility of databases. When users work with usual software tools they have to change their many valued logical thinking (approximate reasoning) into the twovalued computer logic.[5]Structured Query Language (SQL) is a very powerful tool, it satisfy needs for data selection based on degree of truth with linguistic expressions . As flexible querying that is based on fuzzy set theory, Medina et al. have developed a server named fuzzy SQL, which supports flexible queries based on GEFRED model. A new architecture of fuzzy DBMS shows the concept of weak coupling with the DBMS SQL Server. Recent studies shows that time cost and resources can be saved by converting fuzzy queries into SQL queries.
منابع مشابه
Fuzzy to SQL Conversion using Gefred Model with the help of MATLAB
For Many Years, achieving unambiguous knowledge has been turned to a serious challenge for human being. The aim of this paper is to emphasize situation when classical {true, false} logic is not adequate for data selection and data classification. Linguistic expression like: high salary, young etc are very often used in life and in statistics. The goal of this paper is brief study of fuzzy logic...
متن کاملFuzzy to SQL Conversion using Gefred Model with the help of MATLAB
For Many Years, achieving unambiguous knowledge has been turned to a serious challenge for human being. The aim of this paper is to emphasize situation when classical {true, false} logic is not adequate for data selection and data classification. Linguistic expression like: high salary, young etc are very often used in life and in statistics. The goal of this paper is brief study of fuzzy logic...
متن کاملانتخاب مناسبترین زبان پرسوجو برای استفاده از فراپیوندها جهت استخراج دادهها در حالت دیتالوگ در سامانه پایگاه داده استنتاجی DES
Deductive Database systems are designed based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a Deductive Database system. Datalog Educational System (DES) is a Deductive Database system that Datalog mode is the default mode in this system. It can extract data to use outer joins with three query la...
متن کاملSystem and Methods for Converting Speech to SQL
This paper concerns with the conversion of a Spoken English Language Query into SQL for retrieving data from RDBMS. A User submits a query as speech signal through the user interface and gets the result of the query in the text format. We have developed the acoustic and language models using which a speech utterance can be converted into English text query and thus natural language processing t...
متن کاملQuerying Capability Enhancement in Database Using Fuzzy Logic
We already know that Structured Query Language (SQL) is a very powerful tool. It handles data, which is crisp and precise in nature.but it is unable to satisfy the needs for data which is uncertain, imprecise, inapplicable and vague in nature. The goal of this work is to use Fuzzy techniques i.e linguistic expressions and degrees of truth whose result are presented in this paper. For this purpo...
متن کامل